Creating Main KPIs and 'Last Refreshed' Card 14


Creating Historical Attrition KPIs:

1. Create 'Total Employee' KPI Card:

2. Create 'Attrition Rate' KPI Card:
3. Create 'Avg Satisfaction' KPI Card:
4. Create 'Avg Tenure Yrs' KPI Card:
5. Create 'Avg Mthly Hrs' KPI Card:
6. Create 'Last Refreshed' Time Card:
Creating Predictive Attrition KPIs:

7. Copy KPIs: Select the five historical KPI cards, excluding the 'Last Refreshed' card. Make copies of these to use as templates for your predictive KPIs.

8. Update Data Sources for Predictive Analysis:  For each copied KPI card, update the data source by switching from the historical dataset to the employee_attrition_predictions dataset. Ensure that each one is updated to represent the predictive version of its historical counterpart, such as changing Historical 'Attrition Rate' to Predictive 'Attrition Rate'.

Configuring Visibility for Historical and Predictive KPIs

9. Prepare for Toggling: Open the Selection Pane and the Bookmarks Pane within Power BI. Select all predictive KPI cards in the Selection Pane, then click to hide them, making them invisible in the current view.

10. Update Historical Attrition Bookmark:
11. Switch to Predictive Attrition Setup:
12. Test Toggle Functionality: Use the toggle buttons or the bookmarks directly to alternate between the Historical Attrition and Predictive Attrition views. Check that clicking the Historical Attrition button displays only the historical KPIs and hides the predictive ones. Confirm that selecting the Predictive Attrition button reveals the predictive KPIs and conceals the historical ones. Remember, the 'Last Refreshed' card should stay visible in both views since it is common to the entire dashboard.




Create card visualizations